<?php

class M_daftar extends CI_Model {

	function kirimemail($uid,$id){
		
		$this->db->where('id',$uid);
		$p=$this->db->get('sp_pendaftaran')->row();
		$this->db->where('id',$id);
		$this->db->where('uid',$uid);
		$u=$this->db->get('sp_siswa')->row();
		
		$hari = array("Minggu","Senin","Selasa","Rabu","Kamis","Jumat","Sabtu");
		$bulan = array("","Januari","Februari","Maret","April","Mei","Juni","Juli","Agustus","September","Oktober","November","Desember");
		
		$tgl_pengumuman=mktime(substr($p->tgl_pengumuman, 11,2),substr($p->tgl_pengumuman, 14,2),NULL ,substr($p->tgl_pengumuman, 3,2),substr($p->tgl_pengumuman, 0,2),substr($p->tgl_pengumuman, 6,4));	
		$tgl_pengumuman=$hari[date("w",$tgl_pengumuman)].", ".date("j",$tgl_pengumuman)." ".$bulan[date("n",$tgl_pengumuman)]." ".date("Y",$tgl_pengumuman);
		if ($p->biaya==0) {
			$biaya="Biaya Gratis Silahkan tunggu hasil pengumuman pada  <b>".$tgl_pengumuman."</b> di web <a href='https://ppd.smkmaarifnu1ajibarang.sch.id'>ppd.smkmaarifnu1ajibarang.sch.id</a> ";
		} else {
			$biaya="<p>
						Silahkan melakukan transfer biaya pendaftaran ke : 
                        <table>
						  <tr>
						    <td>No. Rekening</td>
						    <td>:</td>
						    <td>".$p->no_rek."</td>
						  </tr>
						  <tr>
						    <td>Atas Nama</td>
						    <td>:</td>
						    <td>".$p->nama_rek."</td>
						  </tr>
						  <tr>
						    <td>Sejumlah</td>
						    <td>:</td>
						    <td><b>Rp. ".number_format($p->biaya,2,",",".").',-'." </b></td>
						  </tr>
						</table>
						<hr/>
						 dengan menyertakan No. Id. Pendaftaran pada referensi Untuk memudahkan pengecekan data.
						<hr/>
						Lanjutkan  konfirmasi dengan mengisi form konfirmasi pembayaran awal di web <a href='https://ppd.smkmaarifnu1ajibarang.sch.id'>ppd.smkmaarifnu1ajibarang.sch.id</a> 						dan tunggu hasil pengumuman pada <b>".$tgl_pengumuman."</b>
						<hr/>
                        <table border=\"0\" cellpadding=\"0\" cellspacing=\"0\" class=\"btn btn-primary\">
                          <tbody>
                            <tr>
                              <td align=\"left\">
                                <table border=\"0\" cellpadding=\"0\" cellspacing=\"0\">
                                  <tbody>
                                    <tr>
                                      <td> <a href=\"https://ppd.smkmaarifnu1ajibarang.sch.id/home/konfirmasi_bayar_awal\" target=\"_blank\">Konfirmasi Pembayaran Awal</a> </td>
                                    </tr>
                                  </tbody>
                                </table>
                              </td>
                            </tr>
                          </tbody>
                        </table>";
		}	
		$this->load->library('email');
$html="<!doctype html>
<html>
  <head>
    <meta name=\"viewport\" content=\"width=device-width\" />
    <meta http-equiv=\"Content-Type\" content=\"text/html; charset=UTF-8\" />
    <title>Data Peserta Pendaftaran Online ".$p->nama."</title>
    <style>
      /* -------------------------------------
          GLOBAL RESETS
      ------------------------------------- */
      img {
        border: none;
        -ms-interpolation-mode: bicubic;
        max-width: 100%; }

      body {
        background-color: #f6f6f6;
        font-family: sans-serif;
        -webkit-font-smoothing: antialiased;
        font-size: 14px;
        line-height: 1.4;
        margin: 0;
        padding: 0;
        -ms-text-size-adjust: 100%;
        -webkit-text-size-adjust: 100%; }

      table {
        border-collapse: separate;
        mso-table-lspace: 0pt;
        mso-table-rspace: 0pt;
        width: 100%; }
        table td {
          font-family: sans-serif;
          font-size: 14px;
          vertical-align: top; }

      /* -------------------------------------
          BODY & CONTAINER
      ------------------------------------- */

      .body {
        background-color: #f6f6f6;
        width: 100%; }

      /* Set a max-width, and make it display as block so it will automatically stretch to that width, but will also shrink down on a phone or something */
      .container {
        display: block;
        Margin: 0 auto !important;
        /* makes it centered */
        max-width: 580px;
        padding: 10px;
        width: 580px; }

      /* This should also be a block element, so that it will fill 100% of the .container */
      .content {
        box-sizing: border-box;
        display: block;
        Margin: 0 auto;
        max-width: 580px;
        padding: 10px; }

      /* -------------------------------------
          HEADER, FOOTER, MAIN
      ------------------------------------- */
      .main {
        background: #ffffff;
        border-radius: 3px;
        width: 100%; }

      .wrapper {
        box-sizing: border-box;
        padding: 20px; }

      .content-block {
        padding-bottom: 10px;
        padding-top: 10px;
      }

      .footer {
        clear: both;
        Margin-top: 10px;
        text-align: center;
        width: 100%; }
        .footer td,
        .footer p,
        .footer span,
        .footer a {
          color: #999999;
          font-size: 12px;
          text-align: center; }

      /* -------------------------------------
          TYPOGRAPHY
      ------------------------------------- */
      h1,
      h2,
      h3,
      h4 {
        color: #000000;
        font-family: sans-serif;
        font-weight: 400;
        line-height: 1.4;
        margin: 0;
        Margin-bottom: 30px; }

      h1 {
        font-size: 35px;
        font-weight: 300;
        text-align: center;
        text-transform: capitalize; }

      p,
      ul,
      ol {
        font-family: sans-serif;
        font-size: 14px;
        font-weight: normal;
        margin: 0;
        Margin-bottom: 15px; }
        p li,
        ul li,
        ol li {
          list-style-position: inside;
          margin-left: 5px; }

      a {
        color: #3498db;
        text-decoration: underline; }

      /* -------------------------------------
          BUTTONS
      ------------------------------------- */
      .btn {
        box-sizing: border-box;
        width: 100%; }
        .btn > tbody > tr > td {
          padding-bottom: 15px; }
        .btn table {
          width: auto; }
        .btn table td {
          background-color: #ffffff;
          border-radius: 5px;
          text-align: center; }
        .btn a {
          background-color: #ffffff;
          border: solid 1px #3498db;
          border-radius: 5px;
          box-sizing: border-box;
          color: #3498db;
          cursor: pointer;
          display: inline-block;
          font-size: 14px;
          font-weight: bold;
          margin: 0;
          padding: 12px 25px;
          text-decoration: none;
          text-transform: capitalize; }

      .btn-primary table td {
        background-color: #3498db; }

      .btn-primary a {
        background-color: #3498db;
        border-color: #3498db;
        color: #ffffff; }

      /* -------------------------------------
          OTHER STYLES THAT MIGHT BE USEFUL
      ------------------------------------- */
      .last {
        margin-bottom: 0; }

      .first {
        margin-top: 0; }

      .align-center {
        text-align: center; }

      .align-right {
        text-align: right; }

      .align-left {
        text-align: left; }

      .clear {
        clear: both; }

      .mt0 {
        margin-top: 0; }

      .mb0 {
        margin-bottom: 0; }

      .preheader {
        color: transparent;
        display: none;
        height: 0;
        max-height: 0;
        max-width: 0;
        opacity: 0;
        overflow: hidden;
        mso-hide: all;
        visibility: hidden;
        width: 0; }

      .powered-by a {
        text-decoration: none; }

      hr {
        border: 0;
        border-bottom: 1px solid #f6f6f6;
        Margin: 20px 0; }

      /* -------------------------------------
          RESPONSIVE AND MOBILE FRIENDLY STYLES
      ------------------------------------- */
      @media only screen and (max-width: 620px) {
        table[class=body] h1 {
          font-size: 28px !important;
          margin-bottom: 10px !important; }
        table[class=body] p,
        table[class=body] ul,
        table[class=body] ol,
        table[class=body] td,
        table[class=body] span,
        table[class=body] a {
          font-size: 16px !important; }
        table[class=body] .wrapper,
        table[class=body] .article {
          padding: 10px !important; }
        table[class=body] .content {
          padding: 0 !important; }
        table[class=body] .container {
          padding: 0 !important;
          width: 100% !important; }
        table[class=body] .main {
          border-left-width: 0 !important;
          border-radius: 0 !important;
          border-right-width: 0 !important; }
        table[class=body] .btn table {
          width: 100% !important; }
        table[class=body] .btn a {
          width: 100% !important; }
        table[class=body] .img-responsive {
          height: auto !important;
          max-width: 100% !important;
          width: auto !important; }}

      /* -------------------------------------
          PRESERVE THESE STYLES IN THE HEAD
      ------------------------------------- */
      @media all {
        .ExternalClass {
          width: 100%; }
        .ExternalClass,
        .ExternalClass p,
        .ExternalClass span,
        .ExternalClass font,
        .ExternalClass td,
        .ExternalClass div {
          line-height: 100%; }
        .apple-link a {
          color: inherit !important;
          font-family: inherit !important;
          font-size: inherit !important;
          font-weight: inherit !important;
          line-height: inherit !important;
          text-decoration: none !important; }
        .btn-primary table td:hover {
          background-color: #34495e !important; }
        .btn-primary a:hover {
          background-color: #34495e !important;
          border-color: #34495e !important; } }

    </style>
  </head>
  <body class=\"\">
    <table border=\"0\" cellpadding=\"0\" cellspacing=\"0\" class=\"body\">
      <tr>
        <td>&nbsp;</td>
        <td class=\"container\">
          <div class=\"content\">

            <!-- START CENTERED WHITE CONTAINER -->
           
            <table class=\"main\">

              <!-- START MAIN CONTENT AREA -->
              <tr>
                <td class=\"wrapper\">
                  <table border=\"0\" cellpadding=\"0\" cellspacing=\"0\">
                    <tr>
                      <td>
                        <p>Selamat ".$u->nama.",</p>
                        <p>Kamu telah berhasil melakukan registrasi pendaftaran peserta didik online SMK Ma'arif NU 1 Ajibarang</p>
                        <table>
						  <tr>
						    <td>Nama</td>
						    <td>:</td>
						    <td>".$u->nama."</td>
						  </tr>
						  <tr>
						    <td>Asal Sekolah</td>
						    <td>:</td>
						    <td>".$u->nama_as."</td>
						  </tr>
						  <tr>
						    <td>TTL</td>
						    <td>:</td>
						    <td>".$u->tem_lahir.", ".$u->tan_lahir."</td>
						  </tr>
						  <tr>
						    <td>No. Id. Pendaftaran</td>
						    <td>:</td>
						    <td><b>".$u->no_id."</b></td>
						  </tr>

						</table>
						<hr/>
						".$biaya."
						<hr/>
                        <p>Terimakasih.</p>
                      </td>
                    </tr>
                  </table>
                </td>
              </tr>

            <!-- END MAIN CONTENT AREA -->
            </table>

            <!-- START FOOTER -->
            <div class=\"footer\">
              <table border=\"0\" cellpadding=\"0\" cellspacing=\"0\">
                <tr>
                  <td class=\"content-block\">
                    <span class=\"apple-link\">Panitia PPD SMK Ma'arif NU 1 Ajibarang</span>
                  </td>
                </tr>
                <tr>
                  <td class=\"content-block powered-by\">
                    Copyright &copy; ".date('Y')." <a href=\"https://smkmaarifnu1ajibarang.sch.id\">SMK Ma'arif NU 1 Ajibarang</a>.
                  </td>
                </tr>
              </table>
            </div>
            <!-- END FOOTER -->

          <!-- END CENTERED WHITE CONTAINER -->
          </div>
        </td>
        <td>&nbsp;</td>
      </tr>
    </table>
  </body>
</html>
";
		$result = $this->email
		    ->from('no_reply@smkmaarifnu1ajibarang.sch.id')
		    ->reply_to('ppd@smkmaarifnu1ajibarang.sch.id')    // Optional, an account where a human being reads.
		    ->to($u->email)
		    ->subject('Konfirmasi Pembayaran Awal')
		    ->message($html)
		    ->send();

		    return $result;
	}
	
	
}
